package houseproject_commity.mapper;

import houseproject_commity.entity.Commity;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * Created by ws on 2019/6/23.
 */
public interface CommityMapper {
  @Select("select * from commity where id=#{id}")
    List<Commity> findByid(Integer id);
  @Insert("insert into commity values(#{id},#{commityid},#{commityname},#{imgurl},#{agentid},#{averageprice},#{commityaddress},#{sellnumber})")
  void save(Commity commity);
  @Delete("delete from commity where id=#{id}")
  void del(Integer id);

}
